{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DESCRIPTION","Buyer","Product","Vendor","Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DESCRIPTION","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["A user would copy and paste their generated sales report into the \"Report\" worksheet."]
["Then run the \"item_margin_macro\" found under View > Macros > item_margin_macro."]
["The macro then creates multiple pivot tables."]

{"sheet":"Buyer","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Buyer","(All)"]
["Transaction Source","(All)"]
["Warehouse","(All)"]
["Vendor","(All)"]
[]
[null," "]
["Category Mgr > Commodity > Item","Net Sales ","Actual Cost-Drayage "," Margin "," Margin % "]
["MANAGER 2",918,832,86,9.3681917211328972E-2]
["MANAGER 3",1187,1097,90,7.5821398483572028E-2]
["MANAGER 1",782,673,109,0.13938618925831203]
["Grand Total",2887,2602,285,9.8718392795289225E-2]

{"sheet":"Product","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Category Manager","(All)"]
["Buyer","(All)"]
["Commodity Code","(All)"]
["Warehouse","(All)"]
["Transaction Source","(All)"]
[]
[null," "]
["Item","Net Sales ","Actual Cost-Drayage "," Margin"," Margin %"]
["PRODUCT 6",23,13,10,0.43478260869565216]
["PRODUCT 7",361,341,20,5.5401662049861494E-2]
["PRODUCT 4",191,169,22,0.11518324607329843]
["PRODUCT 9",342,314,28,8.1871345029239762E-2]
["PRODUCT 8",451,421,30,6.6518847006651879E-2]
["PRODUCT 1",240,209,31,0.12916666666666668]
["PRODUCT 10",394,362,32,8.1218274111675121E-2]
["PRODUCT 5",343,309,34,9.9125364431486881E-2]
["PRODUCT 2",249,213,36,0.14457831325301204]
["PRODUCT 3",293,251,42,0.14334470989761092]
["Grand Total",2887,2602,285,9.8718392795289225E-2]

{"sheet":"Vendor","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Category Manager","(All)"]
["Buyer","(All)"]
["Commodity Code","(All)"]
["Warehouse","(All)"]
["Transaction Source","(All)"]
[]
[null," "]
["Vendor","Sum of Net Sales","Sum of Actual Cost-Drayage","Sum of Margin","Sum of Margin %"]
["VENDOR 1",664,591,73,0.10993975903614457]
["VENDOR 2",719,648,71,9.8748261474269822E-2]
["VENDOR 3",607,544,63,0.10378912685337727]
["VENDOR 4",584,533,51,8.7328767123287673E-2]
["VENDOR 5",313,286,27,8.6261980830670923E-2]
["Grand Total",2887,2602,285,9.8718392795289225E-2]

{"sheet":"Report","index":4,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Warehouse","Transaction Source","Product ID","Commodity Code","Category Manager","Vendor","Net Sales","Actual Cost-Drayage","Buyer"]
["WAREHOUSE 1","SO","PRODUCT 5","COMMODITY 2","MANAGER 2","VENDOR 4",40,35,"BUYER 1"]
["WAREHOUSE 1","SO","PRODUCT 4","COMMODITY 2","MANAGER 2","VENDOR 2",17,14,"BUYER 5"]
["WAREHOUSE 1","SO","PRODUCT 2","COMMODITY 1","MANAGER 1","VENDOR 1",30,23,"BUYER 1"]
["WAREHOUSE 1","SO","PRODUCT 5","COMMODITY 2","MANAGER 2","VENDOR 3",41,35,"BUYER 5"]
["WAREHOUSE 1","SO","PRODUCT 2","COMMODITY 1","MANAGER 1","VENDOR 2",38,32,"BUYER 1"]
["WAREHOUSE 1","SO","PRODUCT 4","COMMODITY 2","MANAGER 2","VENDOR 2",50,48,"BUYER 1"]
["WAREHOUSE 1","SO","PRODUCT 5","COMMODITY 2","MANAGER 2","VENDOR 4",80,78,"BUYER 3"]
["WAREHOUSE 1","SO","PRODUCT 9","COMMODITY 3","MANAGER 3","VENDOR 3",79,70,"BUYER 1"]
["WAREHOUSE 1","SO","PRODUCT 10","COMMODITY 3","MANAGER 3","VENDOR 1",51,45,"BUYER 2"]
["WAREHOUSE 1","SO","PRODUCT 5","COMMODITY 2","MANAGER 2","VENDOR 1",79,74,"BUYER 3"]
["WAREHOUSE 1","SO","PRODUCT 10","COMMODITY 3","MANAGER 3","VENDOR 1",32,31,"BUYER 3"]
["WAREHOUSE 1","SO","PRODUCT 8","COMMODITY 3","MANAGER 3","VENDOR 3",95,93,"BUYER 1"]
["WAREHOUSE 1","PI","PRODUCT 4","COMMODITY 2","MANAGER 2","VENDOR 2",90,83,"BUYER 5"]
["WAREHOUSE 1","PI","PRODUCT 10","COMMODITY 3","MANAGER 3","VENDOR 1",71,67,"BUYER 2"]
["WAREHOUSE 2","PI","PRODUCT 3","COMMODITY 1","MANAGER 1","VENDOR 5",91,88,"BUYER 4"]
["WAREHOUSE 2","SO","PRODUCT 9","COMMODITY 3","MANAGER 3","VENDOR 2",74,69,"BUYER 2"]
["WAREHOUSE 2","SO","PRODUCT 7","COMMODITY 2","MANAGER 2","VENDOR 3",51,50,"BUYER 4"]
["WAREHOUSE 2","SO","PRODUCT 2","COMMODITY 1","MANAGER 1","VENDOR 3",78,69,"BUYER 2"]
["WAREHOUSE 2","SO","PRODUCT 8","COMMODITY 3","MANAGER 3","VENDOR 4",94,91,"BUYER 2"]
["WAREHOUSE 2","SO","PRODUCT 10","COMMODITY 3","MANAGER 3","VENDOR 1",93,86,"BUYER 3"]
["WAREHOUSE 2","SO","PRODUCT 10","COMMODITY 3","MANAGER 3","VENDOR 3",48,44,"BUYER 2"]
["WAREHOUSE 2","SO","PRODUCT 6","COMMODITY 2","MANAGER 2","VENDOR 3",23,13,"BUYER 4"]
["WAREHOUSE 2","SO","PRODUCT 4","COMMODITY 2","MANAGER 2","VENDOR 4",34,24,"BUYER 5"]
["WAREHOUSE 2","PI","PRODUCT 1","COMMODITY 1","MANAGER 1","VENDOR 4",70,60,"BUYER 4"]
["WAREHOUSE 3","SO","PRODUCT 7","COMMODITY 2","MANAGER 2","VENDOR 1",60,58,"BUYER 2"]
["WAREHOUSE 3","SO","PRODUCT 8","COMMODITY 3","MANAGER 3","VENDOR 4",95,89,"BUYER 5"]
["WAREHOUSE 3","SO","PRODUCT 9","COMMODITY 3","MANAGER 3","VENDOR 1",61,58,"BUYER 5"]
["WAREHOUSE 3","SO","PRODUCT 9","COMMODITY 3","MANAGER 3","VENDOR 5",29,27,"BUYER 3"]
["WAREHOUSE 3","SO","PRODUCT 2","COMMODITY 1","MANAGER 1","VENDOR 3",52,48,"BUYER 5"]
["WAREHOUSE 3","SO","PRODUCT 3","COMMODITY 1","MANAGER 1","VENDOR 1",20,10,"BUYER 3"]
["WAREHOUSE 3","SO","PRODUCT 3","COMMODITY 1","MANAGER 1","VENDOR 4",60,53,"BUYER 4"]
["WAREHOUSE 3","SO","PRODUCT 7","COMMODITY 2","MANAGER 2","VENDOR 4",70,66,"BUYER 4"]
["WAREHOUSE 3","SO","PRODUCT 1","COMMODITY 1","MANAGER 1","VENDOR 3",38,32,"BUYER 1"]
["WAREHOUSE 3","SO","PRODUCT 10","COMMODITY 3","MANAGER 3","VENDOR 1",99,89,"BUYER 5"]
["WAREHOUSE 3","SO","PRODUCT 8","COMMODITY 3","MANAGER 3","VENDOR 2",28,22,"BUYER 4"]
["WAREHOUSE 3","SO","PRODUCT 7","COMMODITY 2","MANAGER 2","VENDOR 2",74,68,"BUYER 3"]
["WAREHOUSE 3","PI","PRODUCT 3","COMMODITY 1","MANAGER 1","VENDOR 1",17,9,"BUYER 4"]
["WAREHOUSE 3","PI","PRODUCT 2","COMMODITY 1","MANAGER 1","VENDOR 1",51,41,"BUYER 1"]
["WAREHOUSE 4","SO","PRODUCT 9","COMMODITY 3","MANAGER 3","VENDOR 2",99,90,"BUYER 4"]
["WAREHOUSE 4","SO","PRODUCT 7","COMMODITY 2","MANAGER 2","VENDOR 5",69,64,"BUYER 2"]
["WAREHOUSE 4","SO","PRODUCT 8","COMMODITY 3","MANAGER 3","VENDOR 2",66,58,"BUYER 1"]
["WAREHOUSE 4","SO","PRODUCT 7","COMMODITY 2","MANAGER 2","VENDOR 2",37,35,"BUYER 5"]
["WAREHOUSE 4","SO","PRODUCT 3","COMMODITY 1","MANAGER 1","VENDOR 3",29,22,"BUYER 3"]
["WAREHOUSE 4","SO","PRODUCT 8","COMMODITY 3","MANAGER 3","VENDOR 3",73,68,"BUYER 4"]
["WAREHOUSE 4","SO","PRODUCT 5","COMMODITY 2","MANAGER 2","VENDOR 2",55,49,"BUYER 4"]
["WAREHOUSE 4","SO","PRODUCT 5","COMMODITY 2","MANAGER 2","VENDOR 5",48,38,"BUYER 4"]
["WAREHOUSE 4","SO","PRODUCT 1","COMMODITY 1","MANAGER 1","VENDOR 4",41,37,"BUYER 4"]
["WAREHOUSE 4","SO","PRODUCT 1","COMMODITY 1","MANAGER 1","VENDOR 2",81,74,"BUYER 5"]
["WAREHOUSE 4","SO","PRODUCT 1","COMMODITY 1","MANAGER 1","VENDOR 2",10,6,"BUYER 4"]
["WAREHOUSE 4","PI","PRODUCT 3","COMMODITY 1","MANAGER 1","VENDOR 5",76,69,"BUYER 1"]